package com.lnking.lnkingplace.mapper;


import com.lnking.lnkingplace.model.dto.recordUser.RecordDetailDto;
import com.lnking.lnkingplace.model.dto.specialPlace.SpecialPlaceDetailDto;
import com.lnking.lnkingplace.model.entity.SpecialPlace;
import com.lnking.starter.mybatis.mapper.CustomBaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.Collection;
import java.util.List;

/**
 * <p>
 * 场所信息表 Mapper 接口
 * </p>
 *
 * @author sn
 * @since 2022-09-18
 */
public interface SpecialPlaceMapper extends CustomBaseMapper<SpecialPlace> {

    SpecialPlaceDetailDto getDetail(String id);

    @Select(" SELECT DISTINCT place_type FROM special_place ")
    List<String> getType();

    @Select(" SELECT * FROM special_place WHERE place_name=#{placeName} ")
    SpecialPlace getByName(String placeName);
}
